insert overwrite table jms_dwd.dwd_tab_barscan_cycle_transfer_record_base_dt
select
    id
    ,transfer_code
    ,task_code as shipment_no
    ,transfer_type
    ,scan_time
    ,scan_network_code
    ,scan_network_name
    ,recycle_bags_number
    ,recycle_bags_weight
    ,next_network_code
    ,next_network_name
    ,scan_by_name
    ,scan_by_code
    ,upload_time
    ,package_quantity
from jms_ods.cycle_transfer_record
where dt = '{{ execution_date | cst_ds }}'
;